SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and(InteriorFeat like '%Fireplace%') and(InteriorFeat like '%Fireplace%')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Discover a rare gem in the heart of Lebanon—this expansive single level 4-bedroom, 4-bathroom home is nestled on 43 picturesque acres. Enjoy stunning westerly views, ample living space, and the perfect blend of privacy and convenience. This unique property offers the tranquility of country living with all the benefits of being close to town. With several acres of open pasture land and a barn/stable, the property would be well suited for horses or other grazing animals. The 10 KW solar array reduces current power demands with room for future expansion. Imagine snowshoeing, and cross-country skiing on your own land in the winter while enjoying the pollinator flowers and organic vegetable gardens by the half basketball court. The downstairs includes a library, bar, and a large space to create what you want. In addition, the property benefits from easy access to downtown Lebanon, Dartmouth College, Dartmouth-Hitchcock, I89 and I91, Lebanon Airport, and the Dartmouth Coach, which goes to New York or Boston. Don’t miss out on this exceptional opportunity located at the end of a dead-end road! Home is being sold as is. The property does need work to make it special again.
Description:This beautifully renovated Hanover home offers a rare opportunity with a great price and modern updates. Nearly fully updated on both levels, the home is filled with natural light and features a comfortable, efficient floor plan. Located just 10 minutes from downtown Hanover, it's tucked away from the road and surrounded by trees. The flat yard is perfect for outdoor activities. A heated, direct-entry two-car garage leads to the lower level, which includes a newly renovated family room and a flexible space that can serve as a rec room, exercise room, or guest bedroom. A stylish 3/4 bath adds extra convenience, along with a small laundry room with a stackable washer and dryer. The second level is where the home truly shines. The main living area features a modern kitchen with a large sit-up island, Quartz countertops, and a seamless flow into the dining and living areas. A cozy pellet stove adds warmth, while a mini-split unit ensures comfort in summer. The inviting color palette and layout are perfect for entertaining. Just off the kitchen, the deck is ideal for summer BBQs. This level also includes three bedrooms, each with its own mini-split for personalized climate control, and a fully renovated full bath. Sellers installed a brand new septic in 2019. Come see what this property has to offer. Showings begin at the open house on Saturday, April 5th and Sunday, April 6th 9am to 12pm.
Description:Bring you chickens, your green thumb and your swim suit and enjoy everything this 3.2+/- acre property has to offer approx. 15 minutes from Dartmouth College and Dartmouth Health! This 3-4 bedroom, 2.5 bedroom home features charming exposed beams, open eat-in kitchen/dining room with a wood fireplace, cozy living room with reading nook and a wood stove for those chilly winter nights, a patio leading to a screened porch, garden space, multiple outbuildings and a swimming and skating pond! This home has something for everyone including a trail network within walking distance and Trescott trail access off of Dogford Rd. for mountain biking about 3 miles away. Do you love to ski? The Dartmouth Skiway is approx. 15 minutes as well! What a spot! Delayed showings start at the Open House on Saturday, Feb 15 from 11:00-1:00. Note - Town has it listed as a 3 bedroom so we assume it's a 3 bedroom septic.
Description:This light-filled, contemporary home with 3 bedrooms and 2.5 baths is situated in a highly desirable cul-de-sac located mere minutes from downtown Hanover and Dartmouth College. The kitchen opens into a bright dining area with cathedral ceiling. A sunbathed living room with fireplace, a cozy family room and a home office complete the first floor. The primary bedroom with ensuite bathroom, as well as two nicely sized bedrooms and a full bath comprise the second floor. Enjoy the options of a finished basement with natural light. The outdoor space is highlighted by a great back deck overlooking a cleared backyard. Further outdoor enjoyment awaits at Storrs Pond Recreation Area and trail network- just a mile away. A terrific home in premier neighborhood and location! The office photo is virtually staged. SHOWINGS BEGIN FRIDAY, 3/28/25.
Description:**Open House Saturday 4/12 and Sunday 4/13 from 11:00 - 3:00!** Just 15 minutes from DHMC, Dartmouth College, AND 12A, this thoughtfully updated ranch offers the peace and quiet of a rural setting within a wonderful neighborhood. A large kitchen (with Crown Point cabinetry, marble countertops, and newer appliances), spacious living areas, three bedrooms, and updated 3/4 primary and full hall baths complete the main floor. Downstairs you'll find another bedroom, family room, and office (all with new carpet), a full bath, laundry/workshop, and storage galore. New paint, garage door system, wood shed, Trex deck, fenced yard, mature flower gardens, and raised vegetable gardens enhance the exterior. Energy efficiency is a priority: windows installed since 2017 are Anderson 400 Low-E, a fully-owned 10-megawatt solar panel system, an electric heat pump hot water heater for domestic hot water, and a Level-2 CCS EV charger. Too many updates to name here - a full list available upon request.